Spread ASP.NET 16
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / SetConditionalFormatting Method / SetConditionalFormatting(CellRange[],Boolean,IConditionalFormattingRule[]) Method
The cell ranges
Rule(s) can be merged into an existing conditional format if they affect the same cell range(s).
The specified rules to apply for a specified range of cells
Example


In This Topic
    SetConditionalFormatting(CellRange[],Boolean,IConditionalFormattingRule[]) Method
    In This Topic
    Sets conditional formatting for specified ranges of cells on the sheet based on specified rules.
    Syntax
    'Declaration
     
    Public Overloads Sub SetConditionalFormatting( _
       ByVal cellRanges() As CellRange, _
       ByVal combinable As Boolean, _
       ByVal ParamArray rules() As IConditionalFormattingRule _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim cellRanges() As CellRange
    Dim combinable As Boolean
    Dim rules() As IConditionalFormattingRule
     
    instance.SetConditionalFormatting(cellRanges, combinable, rules)
    public void SetConditionalFormatting( 
       CellRange[] cellRanges,
       bool combinable,
       params IConditionalFormattingRule[] rules
    )

    Parameters

    cellRanges
    The cell ranges
    combinable
    Rule(s) can be merged into an existing conditional format if they affect the same cell range(s).
    rules
    The specified rules to apply for a specified range of cells
    Example
    This example sets the SetConditionalFormatting method.
    See Also